UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PzoBKwzUcYvVUP9Yt6Gn0T3QI9oagolGDwjQca0gxX8='
WHERE
key_id = 'be068b03a774038ece2670e830f47897c7993146c5b3e088899915be0a25c173'
AND (
token = 'PzoBKwzUcYvVUP9Yt6Gn0T3QI9oagolGDwjQca0gxX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)