UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYPR18l4rjOFcJyGanXSZTTtwgRVj7RPEET8Q39/WgU='
WHERE
key_id = '225a8b8615f97952163b192dc9492caeca07a6b3094bb5eb8e08a431c0b76e4e'
AND (
token = 'gYPR18l4rjOFcJyGanXSZTTtwgRVj7RPEET8Q39/WgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)