SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1e2c5713a6e31be32171bda72276488980040e18b15e079a89979030bad4112b' 
  AND token = '59hI5Bw8N6BuFmU4n7VEp93FxVfvtab1bsCfbhCkX0U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}