UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tfib8QcR0cQmy/K9NOg1mp8KO7euFmcxCafrauyZofw='
WHERE
key_id = '40ef26c636071e79eef2319224e1039a2e1ab949f0e0e02c77745448d5807534'
AND (
token = 'tfib8QcR0cQmy/K9NOg1mp8KO7euFmcxCafrauyZofw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)