UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2tar7LQZbOOknWlBOei/U3m9q842gto/s5BnPpTsCN0='
WHERE
key_id = '7e006189d7a332bf907b8329ab72a23b669874b153aedb6b77ea9db594bc0374'
AND (
token = '2tar7LQZbOOknWlBOei/U3m9q842gto/s5BnPpTsCN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)