UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1866yPq9SFvOWWXPV1XxBaWK1BfAUyCzA3nzXX+VSc='
WHERE
key_id = '8865327ff01b17a40c5b1778459cdfa56645619a93c598dfebaabe14c14b4fb6'
AND (
token = 'q1866yPq9SFvOWWXPV1XxBaWK1BfAUyCzA3nzXX+VSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)