UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/1IUNak2lQ4FzSFOeavgSHdiH8jGHgfUcIu6kE0VG0='
WHERE
key_id = 'fa141992305de6fce80c198f3058c5da66797e647fce965ac741d7ef6c6f7927'
AND (
token = 'Z/1IUNak2lQ4FzSFOeavgSHdiH8jGHgfUcIu6kE0VG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)