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