SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '940d25878c8ddad6e4190895122e7b59de0c6e582f8f1c846383fee1a5299e36' 
  AND token = 'qs0rrJ7zt51WrrstR101vWu8ELikTShXhf5c7ZK/oE4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00050

JSON explain

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