UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lry0jcq4kprmdDKyGOV7AomnvnXu+OQWMezfTYMguwA='
WHERE
key_id = 'a05d55c3dc975b6ed494746d465020686ae7f1c5fd9a7291975e646d32db0b04'
AND (
token = 'lry0jcq4kprmdDKyGOV7AomnvnXu+OQWMezfTYMguwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)