UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBlwlYsEVgq20kn/2fGlocnXB05Q42uG2TpfGLMWLp4='
WHERE
key_id = '8efe871b2e3fe09abfe6b303e7960c588707432d2c47fa75ceaa9a9e33985705'
AND (
token = 'xBlwlYsEVgq20kn/2fGlocnXB05Q42uG2TpfGLMWLp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)