SELECT 
  1 
FROM 
  vi_lock_keys 
WHERE 
  key_id = '59675c014d47a14b80c9d98e8d431daaaac8735c04e739b23311c7f3cbb996da' 
  AND token = 'hp70INRm7XR+MOq7GbMvmiQ2EfGGZm4psuhDlwlSh1U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00008

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}