UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2BjBm1N9n2sFMuf5SzdgjF3ya2nskbhMsRunfJj4q9E='
WHERE
key_id = 'e785c6a60c6171c300c3e0e52befa54ed4bc8c4d68c70cae766cf84342dd65f2'
AND (
token = '2BjBm1N9n2sFMuf5SzdgjF3ya2nskbhMsRunfJj4q9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)