UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIAgTvAdtdoCgMBn2wBa9JIhz1Ht1dGKn98n24pxeZc='
WHERE
key_id = 'eab37f4e0f98a323d5abdd1d9c4e7fbf106ec23713ee6253d9a06e61f8e09740'
AND (
token = 'ZIAgTvAdtdoCgMBn2wBa9JIhz1Ht1dGKn98n24pxeZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)