UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZonsVeNQWNLMFTogl/euOiOE40oxt+J1nLGPiURpFzU='
WHERE
key_id = '96df64b216035d074e4f069f8db0668cd86b855cea26c5dd1385dea3e0d06231'
AND (
token = 'ZonsVeNQWNLMFTogl/euOiOE40oxt+J1nLGPiURpFzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)