SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd9606718ec5d031f1789efa98b3eb68aec2e6a0353430e6c4e43e4c67be9cfa1' 
  AND token = 'cYuZiem+ziZa0g2dD5lcm2pcOI3yFGB12383snWiado=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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