UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1RHi8nG1sX118IPnhebGerBvtDHJ1Vqsdu4NQKodO8k='
WHERE
key_id = '2faba98ca0a86bbadf062e479ef875cf6925de188c7c7ca8364a2c4dde19acb9'
AND (
token = '1RHi8nG1sX118IPnhebGerBvtDHJ1Vqsdu4NQKodO8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)