UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oGvtglmlU2ysUcitemPXG6QjztRZPVAa9HUdvnZVyRo='
WHERE
key_id = '9e3018cd8b411802e307a79f882a536f3998858645d6b5af5780a78c9baf48d4'
AND (
token = 'oGvtglmlU2ysUcitemPXG6QjztRZPVAa9HUdvnZVyRo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)