UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzKugizHqKk2MxfqllgzpX3C30lnWe4PzIC5axKS3RU='
WHERE
key_id = '0847d71aee4619d57fdfe8151939844b0ebea4f3b1ee31f2b21d02428083eec9'
AND (
token = 'VzKugizHqKk2MxfqllgzpX3C30lnWe4PzIC5axKS3RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)