UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NsTiTZpVpKeu+E7o57aCHWRtNHI1w9QNgq+WRnkTA8='
WHERE
key_id = '932c678a1d8fa85d432ee3f0955d0dcca9885732b6fd87e25271e4102fdde80e'
AND (
token = '3NsTiTZpVpKeu+E7o57aCHWRtNHI1w9QNgq+WRnkTA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)