UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T/46MJobxhqg18XKVPskR6UJfyAHWHt15keg13YpN1c='
WHERE
key_id = 'b6ee1d2fb0c7247b1a6f08e4ffa34eb596dedacc1d3a37cff2a4d18b54327511'
AND (
token = 'T/46MJobxhqg18XKVPskR6UJfyAHWHt15keg13YpN1c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)