SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b06956f2f635eb7322961f99ca3c20576ee41d30dff88132953a3a12d185e428' 
  AND token = 'EYTmXGWwAF2znjMj5Z1Tsi+M08Ik2Xp2hweO4B1NtsA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00016

JSON explain

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