UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bc9lrw6W07HJdS9WD0k3QOhY/YGoBEmcl4QKR6WgzEA='
WHERE
key_id = 'e6076cd0c619177611a300067451b615cb15c2436d95fdf4843ec3d77256e896'
AND (
token = 'Bc9lrw6W07HJdS9WD0k3QOhY/YGoBEmcl4QKR6WgzEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)