UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lVfJadcKp83cwSBJ2zD4EBF21ww5usCG7DqHCRpOKbc='
WHERE
key_id = '47e9e726e43c5fe392c75068d4b8095987b83058d0e5bbeacfeb91f8885a56e5'
AND (
token = 'lVfJadcKp83cwSBJ2zD4EBF21ww5usCG7DqHCRpOKbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)