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