UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/4FzB+rZWj9W9penzfUvOcmvmSxSLb6HRD+gbJ4+JI='
WHERE
key_id = 'c4c828456c182be2efd6ac4c74492b0456ad7cb00b738f61ee60aead259acea8'
AND (
token = 'd/4FzB+rZWj9W9penzfUvOcmvmSxSLb6HRD+gbJ4+JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)