SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7b3c8eafe8043568d1ccfc4cdae85b5bbbdc7620fd32ef0a59a41a2291015550' 
  AND token = 'ukXjx36OuJ7+nyB00FwmRW4TUHSam+3IECwmuFw5VCI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00068

JSON explain

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