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