UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KS0Q6kNqaJH+GhXN7Okjr6HIYdtkobCH9xkEdNIdWAY='
WHERE
key_id = 'ec1d7694a4becebec14abf783908d43f4e54e4155c99a4c40930891238ec0a27'
AND (
token = 'KS0Q6kNqaJH+GhXN7Okjr6HIYdtkobCH9xkEdNIdWAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)