UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9DvvzkUacMSMTS62F3HSFHvczue0TMW6wLcvKah/fk='
WHERE
key_id = '2c3ef455a3ce6e552052e5973b88f2730de31aa9b6de4d4b13daf6bc3fab3f9f'
AND (
token = 'E9DvvzkUacMSMTS62F3HSFHvczue0TMW6wLcvKah/fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)