UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ey7k3cJg64yJs6SJVzaYOmBLc9VTqlmz9m93huf6XZs='
WHERE
key_id = '18971134974eab9855e3e089490a5f549f8684a9b03beef61d372b11429efcdc'
AND (
token = 'ey7k3cJg64yJs6SJVzaYOmBLc9VTqlmz9m93huf6XZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)