UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p99IkiS7ITtEstqYh9uTuZtbnqsnakfWueYOthWN+mg='
WHERE
key_id = 'bc17aadade9cfe283f6572db73f5cbec7ddab45e063691b178ae770d05e3ab65'
AND (
token = 'p99IkiS7ITtEstqYh9uTuZtbnqsnakfWueYOthWN+mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)