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