UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fvAoEbnjbdTMvEi1ULA4x1sebq3KBR8/mdpF7keh53U='
WHERE
key_id = '28402f7eb8bab991a80eef09c15b053851ec77070fb1aaa8159a62b127054398'
AND (
token = 'fvAoEbnjbdTMvEi1ULA4x1sebq3KBR8/mdpF7keh53U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)