UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3p07qzbcV6d26dNnUeYrnPStAi4G1hHSwedeK+AQto='
WHERE
key_id = 'e8ac63b601ac1bd424e5490b2cab0bcb35d1bc671c3441b1a8bbad0dde3b9565'
AND (
token = 'o3p07qzbcV6d26dNnUeYrnPStAi4G1hHSwedeK+AQto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)