UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdeQG3z9TYRIjgL4QKGdA/6LQieBOxjUPgQg+qMPEbM='
WHERE
key_id = 'f78e6ce110094c2d8501f3b8debeec5d03f82cf6db15b89e6370d538728c6c1f'
AND (
token = 'xdeQG3z9TYRIjgL4QKGdA/6LQieBOxjUPgQg+qMPEbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)