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