UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xO4RtZRolkvi8dxr/0dAOgUSRQX/isqqa31Dcd4WSpE='
WHERE
key_id = '95c6b92431b40884616cd755ca37a71891ff5096e251a0d6e677b3034543c8e2'
AND (
token = 'xO4RtZRolkvi8dxr/0dAOgUSRQX/isqqa31Dcd4WSpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)