UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KdUH/CCEZabKi2Y0jtUXJePDy5pr0kXr4neViSiEBR4='
WHERE
key_id = '03d6d5ce5f7d984defe6804471d83a24413078d2f882c365aa49933afcf7c87d'
AND (
token = 'KdUH/CCEZabKi2Y0jtUXJePDy5pr0kXr4neViSiEBR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)