UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCAERvqUYiGadYk67rKUzefHYtOggQKTGHJdFBhpZu4='
WHERE
key_id = '3e5e43d09f0009ffd2ef5d8ceba776eadd54dfc0ddd90054d2cc9690570dbde2'
AND (
token = 'QCAERvqUYiGadYk67rKUzefHYtOggQKTGHJdFBhpZu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)