UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5BOJk0EtUFGRTo5Jh5TLls9FBQyEDb6A0A4+5ugPxUo='
WHERE
key_id = 'b1b8543c87e3414b5c05d2061686bbec608ddc799e9d209dbb4dda02969a5a8e'
AND (
token = '5BOJk0EtUFGRTo5Jh5TLls9FBQyEDb6A0A4+5ugPxUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)