UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rxq9Uti2W+AsNtNOqfTARRxEBlQFQZ0uurVT+3GdBbw='
WHERE
key_id = 'abad22ee1849e395805baf888566d18385dc43226d1e1a0b76112769dc96a635'
AND (
token = 'Rxq9Uti2W+AsNtNOqfTARRxEBlQFQZ0uurVT+3GdBbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)