UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzNDSTAnidbOu2cIcQ1vqjTtwPRI0KXYx9nq9jRyNH8='
WHERE
key_id = '49ffaa2fc07e07f11f0ec1223b55db2fe95c8ed0098fe54c3d105fd229c6469a'
AND (
token = 'CzNDSTAnidbOu2cIcQ1vqjTtwPRI0KXYx9nq9jRyNH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)