UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQB0VAE2jlG/LlNC1dRIFNE3ZHF0HeV9xyzdPWPvaQA='
WHERE
key_id = 'afebd2941ff76e7e1033b2c132e2e1740f9f21beaa8d0d5fc09a23b07af4bdd4'
AND (
token = 'pQB0VAE2jlG/LlNC1dRIFNE3ZHF0HeV9xyzdPWPvaQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)