UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifeXS7BGAsy8oLlJ6vdR5tQh0cnfXXdIxFYPCztMGi0='
WHERE
key_id = '38745b1298046e7355d7de6cb58cb24d48c63e042bb7d0ac5dd4851dd0a3f53a'
AND (
token = 'ifeXS7BGAsy8oLlJ6vdR5tQh0cnfXXdIxFYPCztMGi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)