UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hB2G5FkxyV/99HSo2H71zdSQPWWYPge99XvT6CPZyfg='
WHERE
key_id = '76b295534ee9a364b2418f22053d299b621ce524324c09dd9b79e8a2162c7a12'
AND (
token = 'hB2G5FkxyV/99HSo2H71zdSQPWWYPge99XvT6CPZyfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)