SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2ab96f2e65b64bc80425a2abe0ee8d5043a90c768889fe146a60e7904a8f0645' 
  AND token = 'id9NRmtYU46Hlvo7IsCPBFc8myqM8henMVZ3Lx3kOEI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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