SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '35f6a1ed888f806b7703423bd196a6ea34bef4eb5d662125553ced9830210f3f' 
  AND token = '25ScFEwpssiLZUnoJaQA651Hp2pZAdanG0OUBvBx4T0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00039

JSON explain

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